-- created by kumiler
-- on 2023/3/11 16:44
-- DESC

create external table jms_ods.sys_agency_area_city
(
    id             int comment 'id',
    agency_area_id int comment '区域维护表id',
    city_id        int comment '管辖区域城市id',
    city_name      string comment '管辖区域城市名称',
    city_code      string comment '管辖区域城市code'
)
    comment '区域维护表关联城市'
    PARTITIONED BY (dt string COMMENT '更新/创建日期 (yyyy-MM-dd)')
    stored as parquet
    LOCATION '/dw/hive/jms_ods.db/external/sys_agency_area_city';